package com.meet.service;

import com.meet.entity.BoardRoom;
import com.meet.entity.Department;
import com.meet.entity.PageBean;

import java.sql.SQLException;
import java.util.List;

/**
 * @author RicardoZeng
 * @date 2022/8/11 20:32
 */
public interface DepartmentService {

    /**
     * 获取所有部门
     * @return
     * @throws SQLException
     */
    public List<Department> getAllDepartment(int currentpage, int rows) throws SQLException;

    /**
     * 添加部门
     * @param department
     * @return
     * @throws SQLException
     */
    public int addDepartment(Department department) throws SQLException;

    /**
     * 删除部门
     * @param Id
     * @return
     * @throws SQLException
     */
    public int delDepartment(Integer Id) throws SQLException;

    /**
     * 修改部门
     * @param department
     * @return
     * @throws SQLException
     */
    public int updateDepartment(Department department) throws SQLException;

    /**
     * 根据Id查部门
     * @param Id
     * @return
     * @throws SQLException
     */
    public Department getDptId(Integer Id) throws SQLException;

    /**
     * 分页
     * @param _currentPage
     * @param _rows
     * @return
     * @throws SQLException
     */
    public PageBean<Department> getAllDptByPage(String _currentPage, String _rows) throws SQLException;


    public List<Department> getDptName() throws SQLException;
}
